﻿using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace furion.blog.Domain.MySQL
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("house")]
    public class House
    {
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="house_id" ,IsPrimaryKey = true   )]
         public long HouseId { get; set; }
        /// <summary>
        /// 信息标题 
        ///</summary>
         [SugarColumn(ColumnName="title"    )]
         public string Title { get; set; }
        /// <summary>
        /// 信息类型(Lease出租 Sale出售 LoS出租或出售 ) 
        ///</summary>
         [SugarColumn(ColumnName="msg_type"    )]
         public string MsgType { get; set; }
        /// <summary>
        /// 标签 
        ///</summary>
         [SugarColumn(ColumnName="tags"    )]
         public string Tags { get; set; }
        /// <summary>
        /// 描述 
        ///</summary>
         [SugarColumn(ColumnName="desc"    )]
         public string Desc { get; set; }
        /// <summary>
        /// 信息状态(WaitForPub 待发布 Published已发布 Off已下架) 
        ///</summary>
         [SugarColumn(ColumnName="status"    )]
         public string Status { get; set; }
        /// <summary>
        /// 是否删除(YES NO) 
        ///</summary>
         [SugarColumn(ColumnName="is_delete"    )]
         public string IsDelete { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
         [SugarColumn(ColumnName="created_time"    )]
         public DateTime? CreatedTime { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
         [SugarColumn(ColumnName="created_by"    )]
         public long? CreatedBy { get; set; }
        /// <summary>
        /// 更新时间 
        ///</summary>
         [SugarColumn(ColumnName="updated_time"    )]
         public DateTime? UpdatedTime { get; set; }
        /// <summary>
        /// 更新人 
        ///</summary>
         [SugarColumn(ColumnName="updated_by"    )]
         public long? UpdatedBy { get; set; }
        /// <summary>
        /// 省编码 
        ///</summary>
         [SugarColumn(ColumnName="province_code"    )]
         public string ProvinceCode { get; set; }
        /// <summary>
        /// 省名称 
        ///</summary>
         [SugarColumn(ColumnName="province_name"    )]
         public string ProvinceName { get; set; }
        /// <summary>
        /// 城市编码 
        ///</summary>
         [SugarColumn(ColumnName="city_code"    )]
         public string CityCode { get; set; }
        /// <summary>
        /// 市名称 
        ///</summary>
         [SugarColumn(ColumnName="city_name"    )]
         public string CityName { get; set; }
        /// <summary>
        /// 县区编码 
        ///</summary>
         [SugarColumn(ColumnName="country_code"    )]
         public string CountryCode { get; set; }
        /// <summary>
        /// 县区名称 
        ///</summary>
         [SugarColumn(ColumnName="country_name"    )]
         public string CountryName { get; set; }
        /// <summary>
        /// 镇编码 
        ///</summary>
         [SugarColumn(ColumnName="town_code"    )]
         public string TownCode { get; set; }
        /// <summary>
        /// 镇名称 
        ///</summary>
         [SugarColumn(ColumnName="town_name"    )]
         public string TownName { get; set; }
        /// <summary>
        /// 村编码 
        ///</summary>
         [SugarColumn(ColumnName="village_code"    )]
         public string VillageCode { get; set; }
        /// <summary>
        /// 村名称 
        ///</summary>
         [SugarColumn(ColumnName="village_name"    )]
         public string VillageName { get; set; }
        /// <summary>
        /// 详细地址 
        ///</summary>
         [SugarColumn(ColumnName="addr"    )]
         public string Addr { get; set; }
        /// <summary>
        /// 排序(数值越大越靠前) 
        ///</summary>
         [SugarColumn(ColumnName="sort_num"    )]
         public int? SortNum { get; set; }
        /// <summary>
        /// 图片 
        ///</summary>
         [SugarColumn(ColumnName="posters"    )]
         public string Posters { get; set; }
    }
}
